FaYear 
Logical Entity Name  FaYear 
Default Table Name  FaYear 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

FaYear Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Code    char(9)  NO 
 
Descrip    varchar(30)  NO 
 
StartDate    datetime  NO 
 
EndDate    datetime  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
UserID    int  NO 
 
Active    bit  NO 
 
ModFlag    char(1)  NO 
 
ts    timestamp  NO 
 
FaYearID(PK)    char(2)  NO 
 
DisplayInUI    int  NO 
 

FaYear Primary and Unique Keys 
Key Name  Key Type  Keys 
FaYear_FaYearID_U_C_IDX  PrimaryKey  FaYearID 

FaYear Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
AdGainfulEmploymentAwardYearSchema  Non-Identifying  One To Zero or More  FK_AdGainfulEmploymentAwardYearSchemaFaYearId_FaYearFaYearId        NO  YES 
AdGainfulEmploymentReportingDetails  Non-Identifying  One To Zero or More  FK_AdGainfulEmploymentReportingDetailsFaYearID_FaYearFaYearID        NO  YES 
FaAaiTaxRate  Non-Identifying  One To Zero or More  FK_FaAaiTaxRateFaYearId_FaYearFaYearId        NO  YES 
FaAwardYearMaxAmt  Non-Identifying  One To Zero or More  FK_FaAwardYearMaxAmt_FaYearID_FaYear_FaYearID        NO  YES 
FaAwardYearPellGrid  Non-Identifying  One To Zero or More  FK_FaAwardYearPellGridFaYearId_FaYearFaYearId        NO  YES 
FaEducationSavingsAllowance  Non-Identifying  One To Zero or More  FK_FaEducationSavingsAllowanceFaYearId_FaYearFaYearId        NO  YES 
FaFAFSAAwardYearSchema  Non-Identifying  One To Zero or More  FK_FaFAFSAAwardYearSchemaFaYearId_FaYearFaYearId        NO  YES 
FaIncomeProtectionAllowance  Non-Identifying  One To Zero or More  FK_FaIncomeProtectionAllowanceFaYearId_FaYearFaYearId        NO  YES 
FaISIRAssumption  Non-Identifying  One To Zero or More  FK_FaISIRAssumptionFaYearId_FaYearFaYearId        NO  YES 
FaISIRAwardYearSchema  Non-Identifying  One To Zero or More  FK_FaISIRAwardYearSchemaFaYearId_FaYearFaYearId        NO  YES 
FaISIRCorrection  Non-Identifying  One To Zero or More  FK_FaISIRCorrectionFaYearId_FaYearFaYearId        NO  YES 
FaISIRImportTrackLog  Non-Identifying  One To Zero or More  FK_FaISIRImportTrackLogFaYearId_FaYearFaYearId        NO  YES 
FaISIRRejection  Non-Identifying  One To Zero or More  FK_FaISIRRejectionFaYearId_FaYearFaYearId        NO  YES 
FaISIRSparseData  Non-Identifying  One To Zero or More  FK_FaISIRSparseData_FaYearId_FaYear_FaYearId        NO  YES 
FaISIRStudentMatch  Non-Identifying  One To Zero or More  FK_FaISIRStudentMatchFaYearId_FaYearFaYearId        NO  YES 
FaNetWorthAdjustment  Non-Identifying  One To Zero or More  FK_FaNetWorthAdjustmentFaYearId_FaYearFaYearId        NO  YES 
FaSocialSecurityTaxRate  Non-Identifying  One To Zero or More  FK_FaSocialSecurityTaxRateFaYearId_FaYearFaYearId        NO  YES 
FaStateTaxAllowance  Non-Identifying  One To Zero or More  FK_FaStateTaxAllowanceFaYearId_FaYearFaYearId        NO  YES 
FaYearExternalMap  Non-Identifying  One To Zero or More  FK_FaYearExternalMapFaYearId_FaYearFaYearId        NO  YES 

FaYear Check Constraints 
Check Constraint Name  CheckConstraint 

FaYear Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group   

FaYear Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.AwardYear 
NO       
Physical (Microsoft SQL Server)
dbo.FaYear 
NO       

FaYear Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Academic Records 
Physical (Microsoft SQL Server)  Financial Aid 

FaYear Data Movement Rules 
Name  Type  Rule Text/Value